Navicat allows you to restore your database/execute SQL file using the Execute SQL File feature.
- Select the database/schema.
- Control-click and select Execute SQL File from the popup menu.
Note: You can drag a .sql file to a database or a server in the connection tree. Navicat will popup the Execute SQL File.
Example:
[Execute Batch log]
Server: Localhost
Database: report
Batch file: /Users/siuha/Desktop/report_sample.sql
(2010-03-16 10:46:42) execution started
(2010-03-16 10:46:43) execution finished
went through 35 queries
0 errors encountered
See also:
Dump SQL File